- Posts: 23
- Thank you received: 1
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `ls_ans
- Ruif
- Topic Author
- Offline
- Junior Member
Less
More
4 weeks 1 day ago #259175
by Ruif
SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `ls_ans was created by Ruif
Please help us help you and fill where relevant:
Your LimeSurvey version: 6.5.1+240320 after updating from 6.3.9+231211
Own server or LimeSurvey hosting: Own server
Survey theme/template:Bootstrap Vanilla
MHP_extends_vanilla
==================
After a manual update from 6.3.9 to 6.5.1, a database update is requested. This results in The following error(dutch translation):
Het updaten is mislukt. Foutgegevens:
CDbCommand faalde tijdens het uitvoeren van volgend SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `ls_answers_idx`; check that it exists
Bestand Update_618.php, regel 14.
Any suggestions?
Your LimeSurvey version: 6.5.1+240320 after updating from 6.3.9+231211
Own server or LimeSurvey hosting: Own server
Survey theme/template:Bootstrap Vanilla
MHP_extends_vanilla
==================
After a manual update from 6.3.9 to 6.5.1, a database update is requested. This results in The following error(dutch translation):
Het updaten is mislukt. Foutgegevens:
CDbCommand faalde tijdens het uitvoeren van volgend SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `ls_answers_idx`; check that it exists
Bestand Update_618.php, regel 14.
Any suggestions?
Please Log in to join the conversation.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
3 weeks 4 days ago #259399
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `ls_ans
1. report the issue
2. Comment this action in Update_618 OR add this index manually.
What is your DATABASE version ?
2. Comment this action in Update_618 OR add this index manually.
What is your DATABASE version ?
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: Ruif
Please Log in to join the conversation.
- Ruif
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 23
- Thank you received: 1
3 weeks 2 days ago #259551
by Ruif
Replied by Ruif on topic SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `ls_ans
Commenting the line in update_618 did the trickk
Please Log in to join the conversation.